package com.woniu.sale.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class PurRequestorderdetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Long offset;

    public PurRequestorderdetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Long offset) {
        this.offset = offset;
    }

    public Long getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("ORDERNO is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("ORDERNO is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("ORDERNO =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("ORDERNO <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("ORDERNO >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERNO >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("ORDERNO <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("ORDERNO <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("ORDERNO like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("ORDERNO not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("ORDERNO in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("ORDERNO not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("ORDERNO between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("ORDERNO not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoIsNull() {
            addCriterion("ORDERLNO is null");
            return (Criteria) this;
        }

        public Criteria andOrderlnoIsNotNull() {
            addCriterion("ORDERLNO is not null");
            return (Criteria) this;
        }

        public Criteria andOrderlnoEqualTo(Integer value) {
            addCriterion("ORDERLNO =", value, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoNotEqualTo(Integer value) {
            addCriterion("ORDERLNO <>", value, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoGreaterThan(Integer value) {
            addCriterion("ORDERLNO >", value, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDERLNO >=", value, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoLessThan(Integer value) {
            addCriterion("ORDERLNO <", value, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoLessThanOrEqualTo(Integer value) {
            addCriterion("ORDERLNO <=", value, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoIn(List<Integer> values) {
            addCriterion("ORDERLNO in", values, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoNotIn(List<Integer> values) {
            addCriterion("ORDERLNO not in", values, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoBetween(Integer value1, Integer value2) {
            addCriterion("ORDERLNO between", value1, value2, "orderlno");
            return (Criteria) this;
        }

        public Criteria andOrderlnoNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDERLNO not between", value1, value2, "orderlno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoIsNull() {
            addCriterion("SourceLNO is null");
            return (Criteria) this;
        }

        public Criteria andSourcelnoIsNotNull() {
            addCriterion("SourceLNO is not null");
            return (Criteria) this;
        }

        public Criteria andSourcelnoEqualTo(Integer value) {
            addCriterion("SourceLNO =", value, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoNotEqualTo(Integer value) {
            addCriterion("SourceLNO <>", value, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoGreaterThan(Integer value) {
            addCriterion("SourceLNO >", value, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("SourceLNO >=", value, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoLessThan(Integer value) {
            addCriterion("SourceLNO <", value, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoLessThanOrEqualTo(Integer value) {
            addCriterion("SourceLNO <=", value, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoIn(List<Integer> values) {
            addCriterion("SourceLNO in", values, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoNotIn(List<Integer> values) {
            addCriterion("SourceLNO not in", values, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoBetween(Integer value1, Integer value2) {
            addCriterion("SourceLNO between", value1, value2, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andSourcelnoNotBetween(Integer value1, Integer value2) {
            addCriterion("SourceLNO not between", value1, value2, "sourcelno");
            return (Criteria) this;
        }

        public Criteria andProdcdIsNull() {
            addCriterion("PRODCD is null");
            return (Criteria) this;
        }

        public Criteria andProdcdIsNotNull() {
            addCriterion("PRODCD is not null");
            return (Criteria) this;
        }

        public Criteria andProdcdEqualTo(String value) {
            addCriterion("PRODCD =", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotEqualTo(String value) {
            addCriterion("PRODCD <>", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdGreaterThan(String value) {
            addCriterion("PRODCD >", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdGreaterThanOrEqualTo(String value) {
            addCriterion("PRODCD >=", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLessThan(String value) {
            addCriterion("PRODCD <", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLessThanOrEqualTo(String value) {
            addCriterion("PRODCD <=", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLike(String value) {
            addCriterion("PRODCD like", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotLike(String value) {
            addCriterion("PRODCD not like", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdIn(List<String> values) {
            addCriterion("PRODCD in", values, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotIn(List<String> values) {
            addCriterion("PRODCD not in", values, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdBetween(String value1, String value2) {
            addCriterion("PRODCD between", value1, value2, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotBetween(String value1, String value2) {
            addCriterion("PRODCD not between", value1, value2, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdflgIsNull() {
            addCriterion("PRODFLG is null");
            return (Criteria) this;
        }

        public Criteria andProdflgIsNotNull() {
            addCriterion("PRODFLG is not null");
            return (Criteria) this;
        }

        public Criteria andProdflgEqualTo(String value) {
            addCriterion("PRODFLG =", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgNotEqualTo(String value) {
            addCriterion("PRODFLG <>", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgGreaterThan(String value) {
            addCriterion("PRODFLG >", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgGreaterThanOrEqualTo(String value) {
            addCriterion("PRODFLG >=", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgLessThan(String value) {
            addCriterion("PRODFLG <", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgLessThanOrEqualTo(String value) {
            addCriterion("PRODFLG <=", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgLike(String value) {
            addCriterion("PRODFLG like", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgNotLike(String value) {
            addCriterion("PRODFLG not like", value, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgIn(List<String> values) {
            addCriterion("PRODFLG in", values, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgNotIn(List<String> values) {
            addCriterion("PRODFLG not in", values, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgBetween(String value1, String value2) {
            addCriterion("PRODFLG between", value1, value2, "prodflg");
            return (Criteria) this;
        }

        public Criteria andProdflgNotBetween(String value1, String value2) {
            addCriterion("PRODFLG not between", value1, value2, "prodflg");
            return (Criteria) this;
        }

        public Criteria andInputunitcdIsNull() {
            addCriterion("INPUTUNITCD is null");
            return (Criteria) this;
        }

        public Criteria andInputunitcdIsNotNull() {
            addCriterion("INPUTUNITCD is not null");
            return (Criteria) this;
        }

        public Criteria andInputunitcdEqualTo(String value) {
            addCriterion("INPUTUNITCD =", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdNotEqualTo(String value) {
            addCriterion("INPUTUNITCD <>", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdGreaterThan(String value) {
            addCriterion("INPUTUNITCD >", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdGreaterThanOrEqualTo(String value) {
            addCriterion("INPUTUNITCD >=", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdLessThan(String value) {
            addCriterion("INPUTUNITCD <", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdLessThanOrEqualTo(String value) {
            addCriterion("INPUTUNITCD <=", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdLike(String value) {
            addCriterion("INPUTUNITCD like", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdNotLike(String value) {
            addCriterion("INPUTUNITCD not like", value, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdIn(List<String> values) {
            addCriterion("INPUTUNITCD in", values, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdNotIn(List<String> values) {
            addCriterion("INPUTUNITCD not in", values, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdBetween(String value1, String value2) {
            addCriterion("INPUTUNITCD between", value1, value2, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andInputunitcdNotBetween(String value1, String value2) {
            addCriterion("INPUTUNITCD not between", value1, value2, "inputunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIsNull() {
            addCriterion("BASICUNITCD is null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIsNotNull() {
            addCriterion("BASICUNITCD is not null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdEqualTo(String value) {
            addCriterion("BASICUNITCD =", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotEqualTo(String value) {
            addCriterion("BASICUNITCD <>", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdGreaterThan(String value) {
            addCriterion("BASICUNITCD >", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdGreaterThanOrEqualTo(String value) {
            addCriterion("BASICUNITCD >=", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLessThan(String value) {
            addCriterion("BASICUNITCD <", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLessThanOrEqualTo(String value) {
            addCriterion("BASICUNITCD <=", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLike(String value) {
            addCriterion("BASICUNITCD like", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotLike(String value) {
            addCriterion("BASICUNITCD not like", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIn(List<String> values) {
            addCriterion("BASICUNITCD in", values, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotIn(List<String> values) {
            addCriterion("BASICUNITCD not in", values, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdBetween(String value1, String value2) {
            addCriterion("BASICUNITCD between", value1, value2, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotBetween(String value1, String value2) {
            addCriterion("BASICUNITCD not between", value1, value2, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andSaleqntyIsNull() {
            addCriterion("SALEQNTY is null");
            return (Criteria) this;
        }

        public Criteria andSaleqntyIsNotNull() {
            addCriterion("SALEQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andSaleqntyEqualTo(Integer value) {
            addCriterion("SALEQNTY =", value, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyNotEqualTo(Integer value) {
            addCriterion("SALEQNTY <>", value, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyGreaterThan(Integer value) {
            addCriterion("SALEQNTY >", value, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("SALEQNTY >=", value, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyLessThan(Integer value) {
            addCriterion("SALEQNTY <", value, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyLessThanOrEqualTo(Integer value) {
            addCriterion("SALEQNTY <=", value, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyIn(List<Integer> values) {
            addCriterion("SALEQNTY in", values, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyNotIn(List<Integer> values) {
            addCriterion("SALEQNTY not in", values, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyBetween(Integer value1, Integer value2) {
            addCriterion("SALEQNTY between", value1, value2, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSaleqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("SALEQNTY not between", value1, value2, "saleqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyIsNull() {
            addCriterion("SALEBASICQNTY is null");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyIsNotNull() {
            addCriterion("SALEBASICQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyEqualTo(Integer value) {
            addCriterion("SALEBASICQNTY =", value, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyNotEqualTo(Integer value) {
            addCriterion("SALEBASICQNTY <>", value, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyGreaterThan(Integer value) {
            addCriterion("SALEBASICQNTY >", value, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("SALEBASICQNTY >=", value, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyLessThan(Integer value) {
            addCriterion("SALEBASICQNTY <", value, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyLessThanOrEqualTo(Integer value) {
            addCriterion("SALEBASICQNTY <=", value, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyIn(List<Integer> values) {
            addCriterion("SALEBASICQNTY in", values, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyNotIn(List<Integer> values) {
            addCriterion("SALEBASICQNTY not in", values, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyBetween(Integer value1, Integer value2) {
            addCriterion("SALEBASICQNTY between", value1, value2, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalebasicqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("SALEBASICQNTY not between", value1, value2, "salebasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyIsNull() {
            addCriterion("RBTQNTY is null");
            return (Criteria) this;
        }

        public Criteria andRbtqntyIsNotNull() {
            addCriterion("RBTQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andRbtqntyEqualTo(Integer value) {
            addCriterion("RBTQNTY =", value, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyNotEqualTo(Integer value) {
            addCriterion("RBTQNTY <>", value, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyGreaterThan(Integer value) {
            addCriterion("RBTQNTY >", value, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("RBTQNTY >=", value, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyLessThan(Integer value) {
            addCriterion("RBTQNTY <", value, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyLessThanOrEqualTo(Integer value) {
            addCriterion("RBTQNTY <=", value, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyIn(List<Integer> values) {
            addCriterion("RBTQNTY in", values, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyNotIn(List<Integer> values) {
            addCriterion("RBTQNTY not in", values, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyBetween(Integer value1, Integer value2) {
            addCriterion("RBTQNTY between", value1, value2, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("RBTQNTY not between", value1, value2, "rbtqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyIsNull() {
            addCriterion("RBTBASICQNTY is null");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyIsNotNull() {
            addCriterion("RBTBASICQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyEqualTo(Integer value) {
            addCriterion("RBTBASICQNTY =", value, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyNotEqualTo(Integer value) {
            addCriterion("RBTBASICQNTY <>", value, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyGreaterThan(Integer value) {
            addCriterion("RBTBASICQNTY >", value, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("RBTBASICQNTY >=", value, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyLessThan(Integer value) {
            addCriterion("RBTBASICQNTY <", value, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyLessThanOrEqualTo(Integer value) {
            addCriterion("RBTBASICQNTY <=", value, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyIn(List<Integer> values) {
            addCriterion("RBTBASICQNTY in", values, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyNotIn(List<Integer> values) {
            addCriterion("RBTBASICQNTY not in", values, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyBetween(Integer value1, Integer value2) {
            addCriterion("RBTBASICQNTY between", value1, value2, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andRbtbasicqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("RBTBASICQNTY not between", value1, value2, "rbtbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyIsNull() {
            addCriterion("ADMITQNTY is null");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyIsNotNull() {
            addCriterion("ADMITQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyEqualTo(Integer value) {
            addCriterion("ADMITQNTY =", value, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyNotEqualTo(Integer value) {
            addCriterion("ADMITQNTY <>", value, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyGreaterThan(Integer value) {
            addCriterion("ADMITQNTY >", value, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("ADMITQNTY >=", value, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyLessThan(Integer value) {
            addCriterion("ADMITQNTY <", value, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyLessThanOrEqualTo(Integer value) {
            addCriterion("ADMITQNTY <=", value, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyIn(List<Integer> values) {
            addCriterion("ADMITQNTY in", values, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyNotIn(List<Integer> values) {
            addCriterion("ADMITQNTY not in", values, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyBetween(Integer value1, Integer value2) {
            addCriterion("ADMITQNTY between", value1, value2, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("ADMITQNTY not between", value1, value2, "admitqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyIsNull() {
            addCriterion("ADMITBASICQNTY is null");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyIsNotNull() {
            addCriterion("ADMITBASICQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyEqualTo(Integer value) {
            addCriterion("ADMITBASICQNTY =", value, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyNotEqualTo(Integer value) {
            addCriterion("ADMITBASICQNTY <>", value, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyGreaterThan(Integer value) {
            addCriterion("ADMITBASICQNTY >", value, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("ADMITBASICQNTY >=", value, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyLessThan(Integer value) {
            addCriterion("ADMITBASICQNTY <", value, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyLessThanOrEqualTo(Integer value) {
            addCriterion("ADMITBASICQNTY <=", value, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyIn(List<Integer> values) {
            addCriterion("ADMITBASICQNTY in", values, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyNotIn(List<Integer> values) {
            addCriterion("ADMITBASICQNTY not in", values, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyBetween(Integer value1, Integer value2) {
            addCriterion("ADMITBASICQNTY between", value1, value2, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andAdmitbasicqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("ADMITBASICQNTY not between", value1, value2, "admitbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyIsNull() {
            addCriterion("OUTQNTY is null");
            return (Criteria) this;
        }

        public Criteria andOutqntyIsNotNull() {
            addCriterion("OUTQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andOutqntyEqualTo(Integer value) {
            addCriterion("OUTQNTY =", value, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyNotEqualTo(Integer value) {
            addCriterion("OUTQNTY <>", value, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyGreaterThan(Integer value) {
            addCriterion("OUTQNTY >", value, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("OUTQNTY >=", value, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyLessThan(Integer value) {
            addCriterion("OUTQNTY <", value, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyLessThanOrEqualTo(Integer value) {
            addCriterion("OUTQNTY <=", value, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyIn(List<Integer> values) {
            addCriterion("OUTQNTY in", values, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyNotIn(List<Integer> values) {
            addCriterion("OUTQNTY not in", values, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyBetween(Integer value1, Integer value2) {
            addCriterion("OUTQNTY between", value1, value2, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("OUTQNTY not between", value1, value2, "outqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyIsNull() {
            addCriterion("OUTBASICQNTY is null");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyIsNotNull() {
            addCriterion("OUTBASICQNTY is not null");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyEqualTo(Integer value) {
            addCriterion("OUTBASICQNTY =", value, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyNotEqualTo(Integer value) {
            addCriterion("OUTBASICQNTY <>", value, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyGreaterThan(Integer value) {
            addCriterion("OUTBASICQNTY >", value, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("OUTBASICQNTY >=", value, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyLessThan(Integer value) {
            addCriterion("OUTBASICQNTY <", value, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyLessThanOrEqualTo(Integer value) {
            addCriterion("OUTBASICQNTY <=", value, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyIn(List<Integer> values) {
            addCriterion("OUTBASICQNTY in", values, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyNotIn(List<Integer> values) {
            addCriterion("OUTBASICQNTY not in", values, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyBetween(Integer value1, Integer value2) {
            addCriterion("OUTBASICQNTY between", value1, value2, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andOutbasicqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("OUTBASICQNTY not between", value1, value2, "outbasicqnty");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNull() {
            addCriterion("SALEPRICE is null");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNotNull() {
            addCriterion("SALEPRICE is not null");
            return (Criteria) this;
        }

        public Criteria andSalepriceEqualTo(BigDecimal value) {
            addCriterion("SALEPRICE =", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotEqualTo(BigDecimal value) {
            addCriterion("SALEPRICE <>", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThan(BigDecimal value) {
            addCriterion("SALEPRICE >", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SALEPRICE >=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThan(BigDecimal value) {
            addCriterion("SALEPRICE <", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SALEPRICE <=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceIn(List<BigDecimal> values) {
            addCriterion("SALEPRICE in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotIn(List<BigDecimal> values) {
            addCriterion("SALEPRICE not in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SALEPRICE between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SALEPRICE not between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalemnyIsNull() {
            addCriterion("SALEMNY is null");
            return (Criteria) this;
        }

        public Criteria andSalemnyIsNotNull() {
            addCriterion("SALEMNY is not null");
            return (Criteria) this;
        }

        public Criteria andSalemnyEqualTo(BigDecimal value) {
            addCriterion("SALEMNY =", value, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyNotEqualTo(BigDecimal value) {
            addCriterion("SALEMNY <>", value, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyGreaterThan(BigDecimal value) {
            addCriterion("SALEMNY >", value, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SALEMNY >=", value, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyLessThan(BigDecimal value) {
            addCriterion("SALEMNY <", value, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SALEMNY <=", value, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyIn(List<BigDecimal> values) {
            addCriterion("SALEMNY in", values, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyNotIn(List<BigDecimal> values) {
            addCriterion("SALEMNY not in", values, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SALEMNY between", value1, value2, "salemny");
            return (Criteria) this;
        }

        public Criteria andSalemnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SALEMNY not between", value1, value2, "salemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyIsNull() {
            addCriterion("WPRICEMNY is null");
            return (Criteria) this;
        }

        public Criteria andWpricemnyIsNotNull() {
            addCriterion("WPRICEMNY is not null");
            return (Criteria) this;
        }

        public Criteria andWpricemnyEqualTo(BigDecimal value) {
            addCriterion("WPRICEMNY =", value, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyNotEqualTo(BigDecimal value) {
            addCriterion("WPRICEMNY <>", value, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyGreaterThan(BigDecimal value) {
            addCriterion("WPRICEMNY >", value, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WPRICEMNY >=", value, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyLessThan(BigDecimal value) {
            addCriterion("WPRICEMNY <", value, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WPRICEMNY <=", value, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyIn(List<BigDecimal> values) {
            addCriterion("WPRICEMNY in", values, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyNotIn(List<BigDecimal> values) {
            addCriterion("WPRICEMNY not in", values, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WPRICEMNY between", value1, value2, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWpricemnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WPRICEMNY not between", value1, value2, "wpricemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyIsNull() {
            addCriterion("WHOLEMNY is null");
            return (Criteria) this;
        }

        public Criteria andWholemnyIsNotNull() {
            addCriterion("WHOLEMNY is not null");
            return (Criteria) this;
        }

        public Criteria andWholemnyEqualTo(BigDecimal value) {
            addCriterion("WHOLEMNY =", value, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyNotEqualTo(BigDecimal value) {
            addCriterion("WHOLEMNY <>", value, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyGreaterThan(BigDecimal value) {
            addCriterion("WHOLEMNY >", value, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WHOLEMNY >=", value, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyLessThan(BigDecimal value) {
            addCriterion("WHOLEMNY <", value, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WHOLEMNY <=", value, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyIn(List<BigDecimal> values) {
            addCriterion("WHOLEMNY in", values, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyNotIn(List<BigDecimal> values) {
            addCriterion("WHOLEMNY not in", values, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WHOLEMNY between", value1, value2, "wholemny");
            return (Criteria) this;
        }

        public Criteria andWholemnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WHOLEMNY not between", value1, value2, "wholemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyIsNull() {
            addCriterion("UPRICEMNY is null");
            return (Criteria) this;
        }

        public Criteria andUpricemnyIsNotNull() {
            addCriterion("UPRICEMNY is not null");
            return (Criteria) this;
        }

        public Criteria andUpricemnyEqualTo(BigDecimal value) {
            addCriterion("UPRICEMNY =", value, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyNotEqualTo(BigDecimal value) {
            addCriterion("UPRICEMNY <>", value, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyGreaterThan(BigDecimal value) {
            addCriterion("UPRICEMNY >", value, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("UPRICEMNY >=", value, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyLessThan(BigDecimal value) {
            addCriterion("UPRICEMNY <", value, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("UPRICEMNY <=", value, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyIn(List<BigDecimal> values) {
            addCriterion("UPRICEMNY in", values, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyNotIn(List<BigDecimal> values) {
            addCriterion("UPRICEMNY not in", values, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPRICEMNY between", value1, value2, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUpricemnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UPRICEMNY not between", value1, value2, "upricemny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyIsNull() {
            addCriterion("UNITMNY is null");
            return (Criteria) this;
        }

        public Criteria andUnitmnyIsNotNull() {
            addCriterion("UNITMNY is not null");
            return (Criteria) this;
        }

        public Criteria andUnitmnyEqualTo(BigDecimal value) {
            addCriterion("UNITMNY =", value, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyNotEqualTo(BigDecimal value) {
            addCriterion("UNITMNY <>", value, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyGreaterThan(BigDecimal value) {
            addCriterion("UNITMNY >", value, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("UNITMNY >=", value, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyLessThan(BigDecimal value) {
            addCriterion("UNITMNY <", value, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("UNITMNY <=", value, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyIn(List<BigDecimal> values) {
            addCriterion("UNITMNY in", values, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyNotIn(List<BigDecimal> values) {
            addCriterion("UNITMNY not in", values, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UNITMNY between", value1, value2, "unitmny");
            return (Criteria) this;
        }

        public Criteria andUnitmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("UNITMNY not between", value1, value2, "unitmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyIsNull() {
            addCriterion("RISETAXMNY is null");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyIsNotNull() {
            addCriterion("RISETAXMNY is not null");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyEqualTo(BigDecimal value) {
            addCriterion("RISETAXMNY =", value, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyNotEqualTo(BigDecimal value) {
            addCriterion("RISETAXMNY <>", value, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyGreaterThan(BigDecimal value) {
            addCriterion("RISETAXMNY >", value, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RISETAXMNY >=", value, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyLessThan(BigDecimal value) {
            addCriterion("RISETAXMNY <", value, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RISETAXMNY <=", value, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyIn(List<BigDecimal> values) {
            addCriterion("RISETAXMNY in", values, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyNotIn(List<BigDecimal> values) {
            addCriterion("RISETAXMNY not in", values, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RISETAXMNY between", value1, value2, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andRisetaxmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RISETAXMNY not between", value1, value2, "risetaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyIsNull() {
            addCriterion("CONTAXMNY is null");
            return (Criteria) this;
        }

        public Criteria andContaxmnyIsNotNull() {
            addCriterion("CONTAXMNY is not null");
            return (Criteria) this;
        }

        public Criteria andContaxmnyEqualTo(BigDecimal value) {
            addCriterion("CONTAXMNY =", value, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyNotEqualTo(BigDecimal value) {
            addCriterion("CONTAXMNY <>", value, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyGreaterThan(BigDecimal value) {
            addCriterion("CONTAXMNY >", value, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CONTAXMNY >=", value, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyLessThan(BigDecimal value) {
            addCriterion("CONTAXMNY <", value, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CONTAXMNY <=", value, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyIn(List<BigDecimal> values) {
            addCriterion("CONTAXMNY in", values, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyNotIn(List<BigDecimal> values) {
            addCriterion("CONTAXMNY not in", values, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CONTAXMNY between", value1, value2, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andContaxmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CONTAXMNY not between", value1, value2, "contaxmny");
            return (Criteria) this;
        }

        public Criteria andDistribstatusIsNull() {
            addCriterion("DISTRIBSTATUS is null");
            return (Criteria) this;
        }

        public Criteria andDistribstatusIsNotNull() {
            addCriterion("DISTRIBSTATUS is not null");
            return (Criteria) this;
        }

        public Criteria andDistribstatusEqualTo(String value) {
            addCriterion("DISTRIBSTATUS =", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusNotEqualTo(String value) {
            addCriterion("DISTRIBSTATUS <>", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusGreaterThan(String value) {
            addCriterion("DISTRIBSTATUS >", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRIBSTATUS >=", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusLessThan(String value) {
            addCriterion("DISTRIBSTATUS <", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusLessThanOrEqualTo(String value) {
            addCriterion("DISTRIBSTATUS <=", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusLike(String value) {
            addCriterion("DISTRIBSTATUS like", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusNotLike(String value) {
            addCriterion("DISTRIBSTATUS not like", value, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusIn(List<String> values) {
            addCriterion("DISTRIBSTATUS in", values, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusNotIn(List<String> values) {
            addCriterion("DISTRIBSTATUS not in", values, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusBetween(String value1, String value2) {
            addCriterion("DISTRIBSTATUS between", value1, value2, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andDistribstatusNotBetween(String value1, String value2) {
            addCriterion("DISTRIBSTATUS not between", value1, value2, "distribstatus");
            return (Criteria) this;
        }

        public Criteria andShortreasonIsNull() {
            addCriterion("ShortReason is null");
            return (Criteria) this;
        }

        public Criteria andShortreasonIsNotNull() {
            addCriterion("ShortReason is not null");
            return (Criteria) this;
        }

        public Criteria andShortreasonEqualTo(String value) {
            addCriterion("ShortReason =", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonNotEqualTo(String value) {
            addCriterion("ShortReason <>", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonGreaterThan(String value) {
            addCriterion("ShortReason >", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonGreaterThanOrEqualTo(String value) {
            addCriterion("ShortReason >=", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonLessThan(String value) {
            addCriterion("ShortReason <", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonLessThanOrEqualTo(String value) {
            addCriterion("ShortReason <=", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonLike(String value) {
            addCriterion("ShortReason like", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonNotLike(String value) {
            addCriterion("ShortReason not like", value, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonIn(List<String> values) {
            addCriterion("ShortReason in", values, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonNotIn(List<String> values) {
            addCriterion("ShortReason not in", values, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonBetween(String value1, String value2) {
            addCriterion("ShortReason between", value1, value2, "shortreason");
            return (Criteria) this;
        }

        public Criteria andShortreasonNotBetween(String value1, String value2) {
            addCriterion("ShortReason not between", value1, value2, "shortreason");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}